Error: Out of Memory (when pasting text into a module because text exceeds 64K).
Error:
Out of Memory
Cause:
The text to be pasted exceeds 64K. In Access, text of more than 64K cannot be pasted from the Clipboard into a module. This is by design of Microsoft Access.
Solution:
As a workaround, copy and paste the text into the module in several small chunks.
1) In the source text file, highlight a chunk of the text to be pasted.
2) Select the 'Edit' menu and select 'Copy'. (The text is copied to the Clipboard.)
3) Switch to Access by choosing the 'Microsoft Access' on the taskbar.
4) Select the 'Window' menu and select the module where the copied text is to be pasted.
5) Select the 'Edit' menu and select 'Paste'. (The text is pasted into the module.)
6) Switch to the text file by choosing the button representing the file on the taskbar.
7) Repeat steps 1) through 6) to copy and paste other chunks of text.
